prepare("insert into extrasales(sdate,department,staff,cash,pos,transfer,credit,Items,qty,admin) values(:a,:b,:s,:c,:p,:t,:cr,:d,:e,:f)") ; $query->bindparam(":a",$edate) ; $query->bindparam(":b",$dept) ; $query->bindparam(":s",$staffs) ; $query->bindparam(":c",$cash) ; $query->bindparam(":p",$pos) ; $query->bindparam(":t",$transfer) ; $query->bindparam(":cr",$credits) ; $query->bindparam(":d",$item) ; $query->bindparam(":e",$qty) ; $query->bindparam(":f",$adm) ; if($query->execute()) $mos = "Sales Submitted Successfully" ; } //} ?> EXTRA SALES

Dashboard

Extra Sales

prepare("select * from extrasales ") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN DATE DEPARTMENT STAFF CASH POS TRANSFER CREDIT ACTIONS
".$count."".$row['sdate']."".$row['department']."".$row['staff']."".$row['cash']."".$row['pos']."".$row['transfer']."".$row['credit']."DELETE